Our Course has two parts:
Theory part: attaches great importance to the principle, technology and introduction of method of the basic model, the main focus is divided into three parts:
Relational database model
Object relational database model
Database system design technology
Practice part: pay attention to the mastery and application of actual database products, class time is thirteen hours, eight practical subject.
| Part | Teaching Content | Learning Content | Slides | Computer Operating |
| 1 | Introduction to database systems | Database system architecture, Database management system, Database system, The history of database |
Introduction to Databases.pptx | |
| 2 | Data model | Entity-Relation model, E-R model design example, XML data structure, Query and transformation |
||
| 3 | Relational database and SQL language | The structure of a relational database, Realtional algebra, SQL language, Query optimization technology |
6 |
|
| 4 | Relational database theory | Paradigm and function, Mode decomposition |
2 |
|
| 5 | Objects and object-relational database theory | Object-oriented data model, Object-relational model, Queries related to the complex type |
4 |
|
| 6 | Database transaction management | The concept of a transaction, Concurrency control, The reply of the database system |
2 |
|
| 7 | The integrity and security | Domain constraints, The integrity of the entity, Referential integrity, Security and authorization |
2 |
|
| 8 | Database design | Database storage environment, High speed connected network, Network database key technology, The design based on E-R model |
Conceptual Database Design.pptx Logical Database Design for the Relational Model.pptx |
2 |
| 9 | Web database design | The characteristics of the WWW server, Web interface of the database |
||
| 10 | Database fleet | Computer fleet overview, Fleet of database, Fleet of database middleware technology, Oracle RAC fleet of database |
||
| 11 | The financial regulatory system based on Internet | Basic finance knowledge, Group company financial system application status, System requirement analysis, The financial regulatory system design, The relational model design, Process and database configuration |
12 |
|
| 12 | Open experiment | Check out Calendar |
12 |